The following instruction guides you through the process of creating a new connection. To successfully establish a new connection to local/remote SQL Server - no matter via SSH, set the connection properties in the corresponding boxes: Connection name, Host name, and Authentication Type.
Connection Name
A friendly name to best describe your connection.
Host Name/IP Address
A host name where the database is situated or the IP address of the server.
Port
A TCP/IP port for connecting to the database server.
Authentication Type
SQL Server uses two ways to validate connections to SQL Server databases: Basic and Windows Authentication.
Basic
SQL Server Authentication uses login records to validate the connection. Users must provide their login username and password every time that they connect.User Name
User name for connecting to the database server.Password
Password for connecting to the server.Windows Authentication
When a user connects through a Windows user account, SQL Server validates the account name and password using the Windows principal token in the operating system. This means that the user identity is confirmed by Windows. SQL Server does not ask for the password, and does not perform the identity validation.Domain
Specify the domain.User Name
Specify the user name for connecting.Password
Specify password for connecting.
If your Internet Service Provider (ISP) does not provide direct access to its server, Secure Tunneling Protocol SSH is another solution.
See also:
Advanced Settings
Related topics:
SSH